CREATING SLICERS & Last Refresh 13
Adding date slicer
Ø Open Visualization pane
Ø Select Slicer visual
Ø Drag the visual to the dashboard.
Ø Click on Date table and drag Year column and place it inside the field.
Ø General: X - Position = 910, Y - Position = 10, Width = 185 and Height = 71
Ø Slider Header = Off
Ø Numeric inputs: Font color = #FFFFFF, Text size = 9, Font family = Segoe UI
Ø Slider = On: Color = #CCCCCC
Ø Title = Off
GIF 1
GIF 2
GIF 3
Adding Class Instructor slicer
Ø Open Visualization pane
Ø Select Slicer visual
Ø Drag the visual to the dashboard.
Ø Click on 'vw_QS_MetricsDashboard_ClassManagement' table and drag 'Class_ClassInstructor' and place it inside the field.
Ø General: X - Position = 10, Y - Position = 409, Width = 197 and Height = 102
Ø Slider Header = Off
Ø Title = On: Title text = Class Instructor: Font Color: #FFFFFF: Background Color: #596DBD: Alignment = Center: Text size = 15: Font Family = Cambria Math
Ø Border = On: Color = #B3B3B3
GIF
Adding Section Name slicer
Ø Open Visualization pane
Ø Select Slicer visual
Ø Drag the visual to the dashboard.
Ø Click on 'vw_QS_MetricsDashboard_ClassManagement' table and drag 'Click on 'vw_QS_MetricsDashboard_ClassManagement' table and drag 'Class_SectionName' column from and place it inside the field.
Ø General: X - Position = 10, Y - Position = 409, Width = 197 and Height = 102
Ø Slider Header = Off
Ø Title = On: Title text = Section Name: Font Color: #FFFFFF: Background Color: #596DBD: Alignment = Center: Text size = 15: Font Family = Cambria Math
Ø Border = On: Color = #B3B3B3
Adding Refresh Visual
Ø Open Visualization pane
Ø Select Card visual
Ø Drag the visual to the dashboard.
Ø Click on Last Refresh table and drag 'LastRefresh' column and place it inside the field.
Ø General: X - Position = 10, Y - Position = 612, Width = 197 and Height = 107
Ø Data Label: Text size = 27: Font Family = DIN
Ø Category = Off
Ø Word wrap = On
Ø Title = On: Title text = Last Refresh: Font Color: #FFFFFF: Background Color: #596DBD: Alignment = Center: Text size = 15: Font Family = Cambria Math
Ø Border = On: Color = #B3B3B3
Ø Title = Off
GIF
Dashboard should look like this
Use the link below creating slicers in power bi:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers